UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DWpYI9IfkXfT82ipwSmk5xyKsq9evVrCtuzD47aEdAI='
WHERE
key_id = '56ce07a1e71fc748ec5c8722411ed497cff947e676c4c39000ffa232b994ea22'
AND (
token = 'DWpYI9IfkXfT82ipwSmk5xyKsq9evVrCtuzD47aEdAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)