UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4YfoDvWn/EbT69vcXFPwO/msA/8VNnIC5XQ6ux4UEE='
WHERE
key_id = 'ce71a46608515a5db3d8c774d997476513ab4197f98f766f2162d583521338e2'
AND (
token = 'D4YfoDvWn/EbT69vcXFPwO/msA/8VNnIC5XQ6ux4UEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)