UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n+pWch6xjgPeD0F6BXnfHPaimMXL/zaAEFaRfJXSn1U='
WHERE
key_id = 'b987775880c91024e40f839309ae9317cda6294e5decaf79b243f196e13d61a3'
AND (
token = 'n+pWch6xjgPeD0F6BXnfHPaimMXL/zaAEFaRfJXSn1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)