UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBCDXnJdHPPzq8CDY7XIUEQkAuPjaE//ts8Umva0sTw='
WHERE
key_id = '8f186878b12a4217d13a309429aea865c862f914e429972902fa3e6590a213fe'
AND (
token = 'UBCDXnJdHPPzq8CDY7XIUEQkAuPjaE//ts8Umva0sTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)