UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9SVcGCejyHzs6aT+zR9xgbcSdgu92jALfG2FddH7+8='
WHERE
key_id = '715b9e148953b38ad36e3fb58a2cd6fe11cbfef1ebe3abc50898a494fd29087b'
AND (
token = 'D9SVcGCejyHzs6aT+zR9xgbcSdgu92jALfG2FddH7+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)