UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j0TibX9CYEpZ+EJHRAhbRcxOVIrmceukEIx1j9s8XQg='
WHERE
key_id = 'b4cd162cc23a0b088261a6b22510f4b01b2a02132a14dd8a5a12a3e8046fe00d'
AND (
token = 'j0TibX9CYEpZ+EJHRAhbRcxOVIrmceukEIx1j9s8XQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)