UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bkUBsaSlENhHciZADuAzB1ACtyqv+PDI3OqRs+8llto='
WHERE
key_id = 'b947a04d4a7f93657651fbaaf8c3c44f210779f8944aa59d159ee8115eea6f27'
AND (
token = 'bkUBsaSlENhHciZADuAzB1ACtyqv+PDI3OqRs+8llto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)