UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4p/+bc+j0uklWNL9jPwuF26OG9IFyGuGwI5bFTZ1UiQ='
WHERE
key_id = '0bc8c64a83f5c61c74effa7ca9c657c1314d297bb1294d4557d08560410ba8f9'
AND (
token = '4p/+bc+j0uklWNL9jPwuF26OG9IFyGuGwI5bFTZ1UiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)