UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l9hAfKbXtY56TIwYHVtEXPSKH5Dmrtg4CIHbx/1B1ZI='
WHERE
key_id = '474239b4831cebc06fa8e160f54cdab1cdce2f4435850277baa558b544d793f0'
AND (
token = 'l9hAfKbXtY56TIwYHVtEXPSKH5Dmrtg4CIHbx/1B1ZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)