UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h1GR5jAZv9wrAyyVQq+8UwL5gXWLa5fw60vp/JCL1Cg='
WHERE
key_id = 'be0f598429d1a7f2118e0ce44e25006a849f457a3ca229c2229ce87cc7c300a4'
AND (
token = 'h1GR5jAZv9wrAyyVQq+8UwL5gXWLa5fw60vp/JCL1Cg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)