UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pGJ4w0SJYQAtmN7o6NkHGgNV0ZgSN7rH9r25bnWGSk='
WHERE
key_id = '434188bb19bb5920c36b689002ef66a97aee552abcaac00af07442e74a573a69'
AND (
token = '0pGJ4w0SJYQAtmN7o6NkHGgNV0ZgSN7rH9r25bnWGSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)