UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdZRhDKUpA/5H4MT2Y1pb0wXZx+El3o/RiBBy+e/uHs='
WHERE
key_id = 'd6a37ab12a6a14a4874e19facaa5a1e841c6e4ba71b5cc835b77d9534a520182'
AND (
token = 'mdZRhDKUpA/5H4MT2Y1pb0wXZx+El3o/RiBBy+e/uHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)