UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+H7+8j2iy1QgmmMYyl3qxPAnqHE34OX532iidfosFUI='
WHERE
key_id = 'f73777f66928f28cdf648bed74fc017738a464bcebbb6517083a13fe61a0152c'
AND (
token = '+H7+8j2iy1QgmmMYyl3qxPAnqHE34OX532iidfosFUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)