UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bn3ztQrsEJD22UIGE9X5F+XFtUpAspyBweJfX0zFaf4='
WHERE
key_id = 'b46caec2b48da4d6b52221646f19b4950bdad01de6f0fcb402d02431f3a1c829'
AND (
token = 'Bn3ztQrsEJD22UIGE9X5F+XFtUpAspyBweJfX0zFaf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)