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