UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2fFYT7HcsvJZHfP1cX3eQW3GyNDo+3IAJmrpJeKwdsg='
WHERE
key_id = '19417892e27033094dce4b7872dcf1d58caf7e65cf9c4996c8337426db985547'
AND (
token = '2fFYT7HcsvJZHfP1cX3eQW3GyNDo+3IAJmrpJeKwdsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)