UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDFLjSEtxDr1oCZwzCQZcHJUylhZu30G/el96hGyIcc='
WHERE
key_id = '18771530d027a7c5d5913d91082309813a09f1637ec09469c51e5db98a4b1166'
AND (
token = 'XDFLjSEtxDr1oCZwzCQZcHJUylhZu30G/el96hGyIcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)