UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Tz4PMa2u7FVmj9cBt9rb9vR9ZocGPA2PJGVDC7I3+I='
WHERE
key_id = 'c702a3dc7a455c269abc047334cb2a5d64bad208eb83ff82cefec625d2fbdfac'
AND (
token = '9Tz4PMa2u7FVmj9cBt9rb9vR9ZocGPA2PJGVDC7I3+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)