UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8jsTxpG2EadsKgQriE6Nd0kMhWvbjuI3rJQedPDuliE='
WHERE
key_id = 'e036cf09492c1bf02cea3d3dc0335db887af6d89b4a7f4df95a9858c89742f6e'
AND (
token = '8jsTxpG2EadsKgQriE6Nd0kMhWvbjuI3rJQedPDuliE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)