UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZGQ2Ys/7BU7G0e7HJRu74ehAFx/6i3w5XE+P99yfoc='
WHERE
key_id = '20dde7abcd3f4192a3276a87d2a431feae6874f395bab300068d3f659731b651'
AND (
token = '0ZGQ2Ys/7BU7G0e7HJRu74ehAFx/6i3w5XE+P99yfoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)