UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '872ztoUg89j1u0H7fqyxeVEeoOZeChz/FEWzmqko198='
WHERE
key_id = '03cd8ab4681031243bc48a17bf075a51693682f06b69aa6b416375736bbbf581'
AND (
token = '872ztoUg89j1u0H7fqyxeVEeoOZeChz/FEWzmqko198='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)