UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hl0Cx7iCpbLryxORpqGz2kqZDW7f7g8keDnnfDoDh70='
WHERE
key_id = 'a1cac13608da303c1b391b6b9a82679817c0f75a0fd1d326c295a33eeac95fad'
AND (
token = 'hl0Cx7iCpbLryxORpqGz2kqZDW7f7g8keDnnfDoDh70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)