UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YZALf4eg8wzYku+eSA6ZwFv0X1Q4DZWG/im20vQVmc='
WHERE
key_id = '6518f319ea056883ab142f02465d29c51292dd22de5b9d7bf8a1b1ab24a49239'
AND (
token = '0YZALf4eg8wzYku+eSA6ZwFv0X1Q4DZWG/im20vQVmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)