UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YD1luPO5Ls92eHhv8r3L0u2Qiw1dzwazcgRaJJAukKM='
WHERE
key_id = '156e69f5e108481565337021a5c1a11119d0d547df40f02488f214766f3bc12c'
AND (
token = 'YD1luPO5Ls92eHhv8r3L0u2Qiw1dzwazcgRaJJAukKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)