UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sp9BBind0un0m53RTh7dY5wRNFh/x/AxDtSq4EnJiB8='
WHERE
key_id = 'b946d0ecf5ed3fdad66a5308eddd8932bba61c1049ce1c685316a22a880d8280'
AND (
token = 'Sp9BBind0un0m53RTh7dY5wRNFh/x/AxDtSq4EnJiB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)