UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZAnnly/XL7Vdi0b3SC9c+s5SAkbc6xbUr8fPqOCTkU='
WHERE
key_id = 'fcb46f5c3e28603f00a6fdf3ec08372e39f34474bdc28001b0816ddf55fc61f6'
AND (
token = 'tZAnnly/XL7Vdi0b3SC9c+s5SAkbc6xbUr8fPqOCTkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)