UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5k2wYCq4EhkDFQkFhx1fa1JEKyh2sEMNFkYPx0hBjYk='
WHERE
key_id = '3a3309f9363752616969756277014295fe3c3ab974fdad55ce1be75d85582353'
AND (
token = '5k2wYCq4EhkDFQkFhx1fa1JEKyh2sEMNFkYPx0hBjYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)