UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNFLPB0j+oERDAF29qZTyN7/3BbTGlLDXjPYVUwpZr4='
WHERE
key_id = '9a5573c0f3b619f5dc6a2a1ffdd86de8c60946416fb97e4f12b8593fbe073c6f'
AND (
token = 'zNFLPB0j+oERDAF29qZTyN7/3BbTGlLDXjPYVUwpZr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)