UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3a371WuYmHsj1EBWv0ZAME3y0NfoAg5N8BgF3Um+27k='
WHERE
key_id = '0310c1b15706affa8e064c6c9466a3505ebb32f31e7136e525588505412e7e4a'
AND (
token = '3a371WuYmHsj1EBWv0ZAME3y0NfoAg5N8BgF3Um+27k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)