UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fCwu6B+ILbWpRVfmef89TfKl6JJUgAy2oaUPbP49afA='
WHERE
key_id = 'd649940b3e577d72cda46baf77ea91a317df1e7dafc5197fdf64e153b4e1b7fd'
AND (
token = 'fCwu6B+ILbWpRVfmef89TfKl6JJUgAy2oaUPbP49afA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)